WhamTech ODBC Driver Diagnostics.. 1

Turn ON ODBC Tracing. 1

Turn ON WhamTech ODBC Driver Logs in EIQ Diagnostics Tool 1

Run the Client Application with Diagnostics ON.. 3

WhamTech ODBC Driver Diagnostics

Follow these steps to troubleshoot the WhamTech ODBC Driver:

·         Close any EIQ ODBC client Application (TOAD, Excel, etc.) if they are running.

 

Turn ON ODBC Tracing

·         Start ODBC Tracing from the ‘ODBC Data Source Administrator’:

o   Save and/or clear the exiting SQL.LOG file.

o   Click 'Start Tracing Now'.

 

 

 

Turn ON WhamTech ODBC Driver Logs in EIQ Diagnostics Tool

Select the following logs in the EIQ Diagnostics Tool

 

·         Xxxxx_EIQ_ODBC 

·         Xxxxx_WHAMNAPI_TOAD (inplace of TOAD it may contain the actual TOAD Analytics application name)

·         Xxxxx_WHAMNAPI_SQLTrace_TOAD inplace of TOAD it may contain the actual TOAD Analytics application name)

·         Xxxxx_WHAMNAPI_EIQServer

·         Xxxxx_EIQ_Server

 

 

·         Make sure to select 'Write diagnostics to log file'.

 

For additional help capturing the diagnostics, see EIQ Diagnostics Tool help.

 

 

·         Save and/or clear the log files under “C:\Program Files\WhamTech\Log\”

 

Run the Client Application with Diagnostics ON

·         Run the ODBC Client Application

·         Once you find the problem, close the Client Application.

·         Save the Diagnostic and ODBC Trace logs and send them to WhamTech technical support.